// 
const {DataTypes, db } = require("../db");
db.define('appSk', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:'租户ID'}, 
billDate:{type: DataTypes.STRING(10),allowNull:false,comment:'当天日期'}, 
billState:{type: DataTypes.STRING(50),allowNull:false,comment:'收款中，已收款,已审核'}, 
doId:{type: DataTypes.INTEGER,allowNull:false,comment:'经办人ID'}, 
billId:{type: DataTypes.INTEGER,allowNull:false,comment:'销售票据ID'}, 
leftAmount:{type: DataTypes.FLOAT,allowNull:false,comment:'应收余额'}, 
nowCheck:{type: DataTypes.FLOAT,comment:'本次收款'}, 
yhAmount:{type: DataTypes.FLOAT,comment:'本次优惠'}, 
jyAmount:{type: DataTypes.FLOAT,comment:'本次收完后结余金额'}, 
receiptId:{type: DataTypes.INTEGER,comment:'收款单据ID'}, 
bak1:{type: DataTypes.STRING(100),comment:'收款的账户信息'}, 
bak2:{type: DataTypes.STRING(100),comment:'备用2'}, 
accountedBy:{type: DataTypes.INTEGER,comment:'审核人'}, 
accountedAt:{type: DataTypes.STRING(20),comment:'审核时间'}, 
createdBy:{type: DataTypes.INTEGER,comment:'创建人'}, 
createdAt:{type: DataTypes.STRING(20),comment:'创建时间'}, 

}, {
    tableName: 'app_sk',
    timestamps: false,
    comment: '注释'
});